﻿TRUNCATE TABLE Config..VROOM_LOG
TRUNCATE TABLE Config..AuditLog

USE Staging
GO
EXEC [sys].[sp_MSforeachtable] 'TRUNCATE TABLE ?'

SELECT name ,size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS int)/128.0 AS AvailableSpaceInMB
FROM sys.database_files;

USE Config
GO
DBCC SHRINKFILE (Config, 2);
DBCC SHRINKFILE (Config_log, 1)
GO


USE Staging
GO
DBCC SHRINKFILE (Staging, 2);
DBCC SHRINKFILE (Staging_log, 1)
GO